Profiling Diabets

Dataset statistics

Number of variables	29
Number of observations	167622
Missing cells	752
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.1 MiB
Average record size in memory	232.0 B

Variable types

NUM	19
CAT	10

Warnings

`total distance (km)` has a high cardinality: 2659 distinct values	High cardinality
`average speed (km/h)` has a high cardinality: 4154 distinct values	High cardinality
`average temperature` has a high cardinality: 528 distinct values	High cardinality
`average wind speed (m/s)` has a high cardinality: 162 distinct values	High cardinality
`max/min gpx height` has a high cardinality: 16341 distinct values	High cardinality
`maxgpsheight` has a high cardinality: 11857 distinct values	High cardinality
`average wind load (1 to -1)` has a high cardinality: 182 distinct values	High cardinality
`avg_heart_rate_cat_org` has a high cardinality: 803 distinct values	High cardinality
`avg_heart_rate_cat_adj` has a high cardinality: 703 distinct values	High cardinality
`uphill8end` is highly correlated with `uphill/downhill hys=8 (m)` and 2 other fields	High correlation
`uphill/downhill hys=8 (m)` is highly correlated with `uphill8end` and 2 other fields	High correlation
`uphill/downhill hys=0 (m)` is highly correlated with `uphill/downhill hys=8 (m)` and 2 other fields	High correlation
`uphill0end` is highly correlated with `uphill/downhill hys=8 (m)` and 2 other fields	High correlation
`uphill/downhill hys=8 (m)` is highly skewed (γ1 = 99.33185539)	Skewed
`uphill8end` is highly skewed (γ1 = 104.3464029)	Skewed
`uphill/downhill hys=0 (m)` is highly skewed (γ1 = 92.11190209)	Skewed
`uphill0end` is highly skewed (γ1 = 96.6644515)	Skewed
`total real energy (kJ)` is highly skewed (γ1 = 281.5546879)	Skewed
`total estimated energy (kJ)` is highly skewed (γ1 = 31.90478045)	Skewed
`average power (W)` is highly skewed (γ1 = 185.9572907)	Skewed
`average estimated power (W)` is highly skewed (γ1 = 32.10429658)	Skewed
`normalized real power (W)` is highly skewed (γ1 = 43.83014039)	Skewed
`normalized estimated power (W)` is highly skewed (γ1 = 53.48094336)	Skewed
`cumulative hr intensity score` is highly skewed (γ1 = -409.3680887)	Skewed
`df_index` has unique values	Unique
`uphill/downhill hys=8 (m)` has 11316 (6.8%) zeros	Zeros
`uphill8end` has 11702 (7.0%) zeros	Zeros
`average wind direction (deg)` has 65199 (38.9%) zeros	Zeros
`total real energy (kJ)` has 96372 (57.5%) zeros	Zeros
`average power (W)` has 96294 (57.4%) zeros	Zeros
`normalized real power (W)` has 96326 (57.5%) zeros	Zeros
`number_of_participants` has 28050 (16.7%) zeros	Zeros
`avg slope length (m)` has 73348 (43.8%) zeros	Zeros

Reproduction

Analysis started	2021-10-14 01:11:19.960149
Analysis finished	2021-10-14 01:13:11.199975
Duration	1 minute and 51.24 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	167622
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	83810.5
Minimum	0
Maximum	167621
Zeros	1
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	8381.05
Q1	41905.25
median	83810.5
Q3	125715.75
95-th percentile	159239.95
Maximum	167621
Range	167621
Interquartile range (IQR)	83810.5

Descriptive statistics

Standard deviation	48388.44775
Coefficient of variation (CV)	0.5773554358
Kurtosis	-1.2
Mean	83810.5
Median Absolute Deviation (MAD)	41905.5
Skewness	-1.516506131e-17
Sum	1.404848363e+10
Variance	2341441876
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
123625	1	< 0.1%
4823	1	< 0.1%
27352	1	< 0.1%
25305	1	< 0.1%
31450	1	< 0.1%
29403	1	< 0.1%
19164	1	< 0.1%
17117	1	< 0.1%
23262	1	< 0.1%
Other values (167612)	167612	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
167621	1	< 0.1%
167620	1	< 0.1%
167619	1	< 0.1%
167618	1	< 0.1%
167617	1	< 0.1%

user-id
Real number (ℝ_≥0)

Distinct	1437
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4236.598394
Minimum	1
Maximum	8210
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1591
Q1	1919
median	2798
Q3	7563
95-th percentile	8122
Maximum	8210
Range	8209
Interquartile range (IQR)	5644

Descriptive statistics

Standard deviation	2658.458945
Coefficient of variation (CV)	0.6274984546
Kurtosis	-1.526379073
Mean	4236.598394
Median Absolute Deviation (MAD)	1204
Skewness	0.3608078996
Sum	710147096
Variance	7067403.962
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7992	3088	1.8%
1770	1864	1.1%
7667	1782	1.1%
7563	1527	0.9%
7883	1412	0.8%
7633	1387	0.8%
7626	1242	0.7%
8065	1228	0.7%
8161	1208	0.7%
1755	1202	0.7%
Other values (1427)	151682	90.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	< 0.1%
6	449	0.3%
7	406	0.2%
13	288	0.2%
16	188	0.1%

Value	Count	Frequency (%)
8210	110	0.1%
8207	14	< 0.1%
8199	746	0.4%
8191	774	0.5%
8186	98	0.1%

m/v
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

M	151750
F	15872

Frequencies
Length

Value	Count	Frequency (%)
M	151750	90.5%
F	15872	9.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

weight
Real number (ℝ_≥0)

Distinct	80
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	75.81507797
Minimum	0
Maximum	267
Zeros	658
Zeros (%)	0.4%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	59
Q1	68
median	75
Q3	83
95-th percentile	95
Maximum	267
Range	267
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	13.20316512
Coefficient of variation (CV)	0.1741495949
Kurtosis	13.26068358
Mean	75.81507797
Median Absolute Deviation (MAD)	7
Skewness	0.855320527
Sum	12708275
Variance	174.3235691
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
68	8544	5.1%
85	8134	4.9%
81	8082	4.8%
75	7658	4.6%
70	7571	4.5%
72	6846	4.1%
80	6424	3.8%
78	6277	3.7%
84	6077	3.6%
71	5876	3.5%
Other values (70)	96133	57.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	658	0.4%
45	43	< 0.1%
49	51	< 0.1%
50	6	< 0.1%
51	1277	0.8%

Value	Count	Frequency (%)
267	2	< 0.1%
214	5	< 0.1%
205	56	< 0.1%
180	19	< 0.1%
172	268	0.2%

age
Real number (ℝ_≥0)

Distinct	63
Distinct (%)	< 0.1%
Missing	752
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%

Mean	41.40496794
Minimum	0
Maximum	76
Zeros	33
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	24
Q1	34
median	41
Q3	49
95-th percentile	62
Maximum	76
Range	76
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.79401958
Coefficient of variation (CV)	0.2606938278
Kurtosis	-0.1306070381
Mean	41.40496794
Median Absolute Deviation (MAD)	7
Skewness	0.2168545966
Sum	6909247
Variance	116.5108587
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	9556	5.7%
39	8985	5.4%
44	8410	5.0%
45	7735	4.6%
36	7456	4.4%
33	6657	4.0%
50	6509	3.9%
40	6346	3.8%
38	6289	3.8%
43	5452	3.3%
Other values (53)	93475	55.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	< 0.1%
14	2	< 0.1%
15	146	0.1%
16	254	0.2%
17	1007	0.6%

Value	Count	Frequency (%)
76	47	< 0.1%
74	13	< 0.1%
73	316	0.2%
72	37	< 0.1%
71	1	< 0.1%

length
Real number (ℝ_≥0)

Distinct	60
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	179.2729833
Minimum	0
Maximum	248
Zeros	658
Zeros (%)	0.4%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	165
Q1	175
median	180
Q3	186
95-th percentile	192
Maximum	248
Range	248
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	14.31349823
Coefficient of variation (CV)	0.07984191468
Kurtosis	96.74006834
Mean	179.2729833
Median Absolute Deviation (MAD)	6
Skewness	-8.019146739
Sum	30050096
Variance	204.8762317
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180	14162	8.4%
178	12995	7.8%
188	9136	5.5%
191	8491	5.1%
179	7455	4.4%
186	7298	4.4%
176	7189	4.3%
177	7166	4.3%
185	7107	4.2%
170	6816	4.1%
Other values (50)	79807	47.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	658	0.4%
60	53	< 0.1%
69	34	< 0.1%
104	19	< 0.1%
105	54	< 0.1%

Value	Count	Frequency (%)
248	56	< 0.1%
208	56	< 0.1%
205	232	0.1%
203	126	0.1%
202	61	< 0.1%

total distance (km)
Categorical

HIGH CARDINALITY

Distinct	2659
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

61	359
60,2	336
60	333
60,1	328
59,9	324
Other values (2654)	165942

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
61	359	0.2%
60,2	336	0.2%
60	333	0.2%
60,1	328	0.2%
59,9	324	0.2%
62,6	316	0.2%
62,4	308	0.2%
61,4	308	0.2%
55,3	307	0.2%
62,9	301	0.2%
Other values (2649)	164402	98.1%

Frequencies of value counts

Unique

Unique	328 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	6
Median length	4
Mean length	3.971274654
Min length	1

average speed (km/h)
Categorical

HIGH CARDINALITY

Distinct	4154
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

28,44	205
25,59	204
26,01	201
26,51	200
28,47	200
Other values (4149)	166612

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
28,44	205	0.1%
25,59	204	0.1%
26,01	201	0.1%
26,51	200	0.1%
28,47	200	0.1%
28,2	199	0.1%
0	199	0.1%
26,19	195	0.1%
26,35	192	0.1%
28,11	190	0.1%
Other values (4144)	165637	98.8%

Frequencies of value counts

Unique

Unique	341 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	7
Median length	5
Mean length	4.859362136
Min length	1

uphill/downhill hys=8 (m)
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	3789
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	458.3105261
Minimum	0
Maximum	238637
Zeros	11316
Zeros (%)	6.8%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	38
median	202
Q3	605
95-th percentile	1708
Maximum	238637
Range	238637
Interquartile range (IQR)	567

Descriptive statistics

Standard deviation	1211.184628
Coefficient of variation (CV)	2.642716149
Kurtosis	15770.52884
Mean	458.3105261
Median Absolute Deviation (MAD)	186
Skewness	99.33185539
Sum	76822927
Variance	1466968.204
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11316	6.8%
8	5189	3.1%
9	3710	2.2%
17	3052	1.8%
18	2104	1.3%
26	1579	0.9%
25	1379	0.8%
27	1300	0.8%
16	1277	0.8%
19	1226	0.7%
Other values (3779)	135490	80.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11316	6.8%
8	5189	3.1%
9	3710	2.2%
10	1222	0.7%
11	428	0.3%

Value	Count	Frequency (%)
238637	1	< 0.1%
188676	1	< 0.1%
164662	1	< 0.1%
117178	2	< 0.1%
96725	1	< 0.1%

uphill8end
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	3706
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	451.2794084
Minimum	0
Maximum	238637
Zeros	11702
Zeros (%)	7.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	38
median	203
Q3	601
95-th percentile	1683
Maximum	238637
Range	238637
Interquartile range (IQR)	563

Descriptive statistics

Standard deviation	1205.596267
Coefficient of variation (CV)	2.671507373
Kurtosis	16891.978
Mean	451.2794084
Median Absolute Deviation (MAD)	186
Skewness	104.3464029
Sum	75644357
Variance	1453462.359
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11702	7.0%
8	5466	3.3%
9	3775	2.3%
17	3768	2.2%
18	1954	1.2%
25	1788	1.1%
26	1665	1.0%
27	1321	0.8%
35	1087	0.6%
10	1039	0.6%
Other values (3696)	134057	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11702	7.0%
8	5466	3.3%
9	3775	2.3%
10	1039	0.6%
11	276	0.2%

Value	Count	Frequency (%)
238637	1	< 0.1%
201283	1	< 0.1%
158734	1	< 0.1%
117178	2	< 0.1%
102376	1	< 0.1%

uphill/downhill hys=0 (m)
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	4131
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	663.5069203
Minimum	0
Maximum	238637
Zeros	195
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	57
Q1	200
median	422
Q3	867
95-th percentile	2004
Maximum	238637
Range	238637
Interquartile range (IQR)	667

Descriptive statistics

Standard deviation	1241.494926
Coefficient of variation (CV)	1.871110742
Kurtosis	14238.05815
Mean	663.5069203
Median Absolute Deviation (MAD)	272
Skewness	92.11190209
Sum	111218357
Variance	1541309.651
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
198	372	0.2%
144	328	0.2%
172	324	0.2%
306	312	0.2%
160	308	0.2%
183	300	0.2%
134	297	0.2%
148	296	0.2%
177	295	0.2%
142	294	0.2%
Other values (4121)	164496	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	195	0.1%
1	23	< 0.1%
2	49	< 0.1%
3	69	< 0.1%
4	113	0.1%

Value	Count	Frequency (%)
238637	1	< 0.1%
188676	1	< 0.1%
164718	1	< 0.1%
117427	2	< 0.1%
96729	1	< 0.1%

uphill0end
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	4035
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	656.7462684
Minimum	0
Maximum	238637
Zeros	265
Zeros (%)	0.2%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	58
Q1	200
median	421
Q3	864
95-th percentile	1983
Maximum	238637
Range	238637
Interquartile range (IQR)	664

Descriptive statistics

Standard deviation	1236.108261
Coefficient of variation (CV)	1.882170208
Kurtosis	15232.38209
Mean	656.7462684
Median Absolute Deviation (MAD)	271
Skewness	96.6644515
Sum	110085123
Variance	1527963.633
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
182	333	0.2%
146	319	0.2%
150	319	0.2%
200	317	0.2%
218	316	0.2%
156	313	0.2%
208	308	0.2%
145	303	0.2%
183	298	0.2%
132	298	0.2%
Other values (4025)	164498	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	265	0.2%
1	47	< 0.1%
2	65	< 0.1%
3	78	< 0.1%
4	102	0.1%

Value	Count	Frequency (%)
238637	1	< 0.1%
201283	1	< 0.1%
158762	1	< 0.1%
117435	2	< 0.1%
102391	1	< 0.1%

average temperature
Categorical

HIGH CARDINALITY

Distinct	528
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	28986
18,1	786
18,4	778
17,7	752
17	746
Other values (523)	135574

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	28986	17.3%
18,1	786	0.5%
18,4	778	0.5%
17,7	752	0.4%
17	746	0.4%
19,3	735	0.4%
17,4	730	0.4%
20,6	728	0.4%
17,8	724	0.4%
18,3	724	0.4%
Other values (518)	131933	78.7%

Frequencies of value counts

Unique

Unique	43 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	4
Mean length	3.149377767
Min length	1

average wind speed (m/s)
Categorical

HIGH CARDINALITY

Distinct	162
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	65222
2	2582
1,9	2569
2,1	2474
1,7	2432
Other values (157)	92343

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	65222	38.9%
2	2582	1.5%
1,9	2569	1.5%
2,1	2474	1.5%
1,7	2432	1.5%
2,6	2419	1.4%
1,6	2416	1.4%
1,5	2409	1.4%
1,8	2387	1.4%
2,5	2322	1.4%
Other values (152)	80390	48.0%

Frequencies of value counts

Unique

Unique	13 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	3
Mean length	2.100702772
Min length	1

average wind direction (deg)
Real number (ℝ_≥0)

ZEROS

Distinct	360
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	110.9212574
Minimum	0
Maximum	359
Zeros	65199
Zeros (%)	38.9%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	76
Q3	216
95-th percentile	311
Maximum	359
Range	359
Interquartile range (IQR)	216

Descriptive statistics

Standard deviation	114.1309145
Coefficient of variation (CV)	1.028936358
Kurtosis	-1.25104972
Mean	110.9212574
Median Absolute Deviation (MAD)	76
Skewness	0.4777341301
Sum	18592843
Variance	13025.86565
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65199	38.9%
240	520	0.3%
221	504	0.3%
233	493	0.3%
235	491	0.3%
222	487	0.3%
230	485	0.3%
210	484	0.3%
203	483	0.3%
226	481	0.3%
Other values (350)	97995	58.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	65199	38.9%
1	78	< 0.1%
2	100	0.1%
3	88	0.1%
4	118	0.1%

Value	Count	Frequency (%)
359	23	< 0.1%
358	48	< 0.1%
357	63	< 0.1%
356	81	< 0.1%
355	70	< 0.1%

max/min gpx height
Categorical

HIGH CARDINALITY

Distinct	16341
Distinct (%)	9.7%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	6610
13	238
11,2	238
9,8	233
20,6	232
Other values (16336)	160071

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6610	3.9%
13	238	0.1%
11,2	238	0.1%
9,8	233	0.1%
20,6	232	0.1%
10,8	232	0.1%
10	231	0.1%
14	220	0.1%
6	219	0.1%
9,6	219	0.1%
Other values (16331)	158950	94.8%

Frequencies of value counts

Unique

Unique	5150 ?
Unique (%)	3.1%

Histogram of lengths of the category

Length

Max length	7
Median length	4
Mean length	4.111441219
Min length	1

maxgpsheight
Categorical

HIGH CARDINALITY

Distinct	11857
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	1303
-3	655
-2	626
-0,2	616
1	600
Other values (11852)	163822

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	1303	0.8%
-3	655	0.4%
-2	626	0.4%
-0,2	616	0.4%
1	600	0.4%
-1	590	0.4%
-0,8	582	0.3%
-2,4	582	0.3%
-0,6	572	0.3%
0,4	551	0.3%
Other values (11847)	160945	96.0%

Frequencies of value counts

Unique

Unique	3865 ?
Unique (%)	2.3%

Histogram of lengths of the category

Length

Max length	7
Median length	4
Mean length	3.927479686
Min length	1

total real energy (kJ)
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	5289
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	952.0742862
Minimum	0
Maximum	10508164
Zeros	96372
Zeros (%)	57.5%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1545
95-th percentile	2967.95
Maximum	10508164
Range	10508164
Interquartile range (IQR)	1545

Descriptive statistics

Standard deviation	36668.71405
Coefficient of variation (CV)	38.51455142
Kurtosis	80479.55897
Mean	952.0742862
Median Absolute Deviation (MAD)	0
Skewness	281.5546879
Sum	159588596
Variance	1344594590
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	96372	57.5%
1392	81	< 0.1%
1469	79	< 0.1%
1480	79	< 0.1%
1733	74	< 0.1%
1494	74	< 0.1%
2003	72	< 0.1%
1560	72	< 0.1%
1592	71	< 0.1%
1495	71	< 0.1%
Other values (5279)	70577	42.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	96372	57.5%
1	28	< 0.1%
2	18	< 0.1%
3	9	< 0.1%
4	7	< 0.1%

Value	Count	Frequency (%)
10508164	2	< 0.1%
1862548	1	< 0.1%
505549	3	< 0.1%
203606	1	< 0.1%
95778	1	< 0.1%

total estimated energy (kJ)
Real number (ℝ)

SKEWED

Distinct	5143
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1254.472736
Minimum	-1543
Maximum	154850
Zeros	223
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-1543
5-th percentile	118
Q1	761
median	1129
Q3	1616
95-th percentile	2691
Maximum	154850
Range	156393
Interquartile range (IQR)	855

Descriptive statistics

Standard deviation	893.4703636
Coefficient of variation (CV)	0.7122278052
Kurtosis	5223.281528
Mean	1254.472736
Median Absolute Deviation (MAD)	418
Skewness	31.90478045
Sum	210277229
Variance	798289.2907
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	223	0.1%
914	158	0.1%
1016	158	0.1%
1116	157	0.1%
1099	152	0.1%
1055	151	0.1%
1077	150	0.1%
942	146	0.1%
864	143	0.1%
955	142	0.1%
Other values (5133)	166042	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1543	1	< 0.1%
-1348	1	< 0.1%
-1150	1	< 0.1%
-1146	1	< 0.1%
-1126	1	< 0.1%

Value	Count	Frequency (%)
154850	1	< 0.1%
24540	2	< 0.1%
20674	1	< 0.1%
17303	1	< 0.1%
16819	2	< 0.1%

average power (W)
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	50334
Distinct (%)	30.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	94426.11477
Minimum	0
Maximum	730107252
Zeros	96294
Zeros (%)	57.4%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	164058.75
95-th percentile	222215
Maximum	730107252
Range	730107252
Interquartile range (IQR)	164058.75

Descriptive statistics

Standard deviation	3394881.246
Coefficient of variation (CV)	35.9527791
Kurtosis	35824.50566
Mean	94426.11477
Median Absolute Deviation (MAD)	0
Skewness	185.9572907
Sum	1.582789421e+10
Variance	1.152521867e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	96294	57.4%
162840	46	< 0.1%
165651	37	< 0.1%
203071	36	< 0.1%
205038	36	< 0.1%
162761	34	< 0.1%
208485	34	< 0.1%
211735	34	< 0.1%
221477	34	< 0.1%
208851	34	< 0.1%
Other values (50324)	71003	42.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	96294	57.4%
3	25	< 0.1%
5	1	< 0.1%
8	4	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
730107252	2	< 0.1%
525392672	3	< 0.1%
188033983	1	< 0.1%
21238839	1	< 0.1%
13179319	1	< 0.1%

average estimated power (W)
Real number (ℝ)

SKEWED

Distinct	95678
Distinct (%)	57.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	119574.6987
Minimum	-643339
Maximum	8690989
Zeros	200
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-643339
5-th percentile	38738.45
Q1	89359.25
median	116919
Q3	145172.75
95-th percentile	197817.1
Maximum	8690989
Range	9334328
Interquartile range (IQR)	55813.5

Descriptive statistics

Standard deviation	73182.0355
Coefficient of variation (CV)	0.6120194013
Kurtosis	2789.574354
Mean	119574.6987
Median Absolute Deviation (MAD)	27902
Skewness	32.10429658
Sum	2.004335014e+10
Variance	5355610320
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	200	0.1%
141352	24	< 0.1%
146744	23	< 0.1%
115225	21	< 0.1%
138694	21	< 0.1%
158198	21	< 0.1%
153339	21	< 0.1%
111716	21	< 0.1%
149536	20	< 0.1%
110571	20	< 0.1%
Other values (95668)	167230	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-643339	1	< 0.1%
-635728	2	< 0.1%
-428132	2	< 0.1%
-393397	1	< 0.1%
-360039	1	< 0.1%

Value	Count	Frequency (%)
8690989	2	< 0.1%
4374261	2	< 0.1%
4247700	2	< 0.1%
3641539	2	< 0.1%
3570980	2	< 0.1%

normalized real power (W)
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	494
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	84.57364188
Minimum	0
Maximum	18724
Zeros	96326
Zeros (%)	57.5%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	186
95-th percentile	243
Maximum	18724
Range	18724
Interquartile range (IQR)	186

Descriptive statistics

Standard deviation	156.9798861
Coefficient of variation (CV)	1.856132509
Kurtosis	3821.328527
Mean	84.57364188
Median Absolute Deviation (MAD)	0
Skewness	43.83014039
Sum	14176403
Variance	24642.68464
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	96326	57.5%
203	784	0.5%
191	761	0.5%
182	732	0.4%
189	723	0.4%
196	719	0.4%
186	717	0.4%
198	716	0.4%
200	706	0.4%
223	698	0.4%
Other values (484)	64740	38.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	96326	57.5%
1	38	< 0.1%
2	13	< 0.1%
3	2	< 0.1%
4	4	< 0.1%

Value	Count	Frequency (%)
18724	1	< 0.1%
17919	1	< 0.1%
13817	1	< 0.1%
12639	1	< 0.1%
11730	1	< 0.1%

normalized estimated power (W)
Real number (ℝ_≥0)

SKEWED

Distinct	1098
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	218.606937
Minimum	0
Maximum	108703
Zeros	200
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	85
Q1	140
median	181
Q3	232
95-th percentile	345
Maximum	108703
Range	108703
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	1045.943502
Coefficient of variation (CV)	4.784585138
Kurtosis	3343.9457
Mean	218.606937
Median Absolute Deviation (MAD)	45
Skewness	53.48094336
Sum	36643332
Variance	1093997.809
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
168	1116	0.7%
172	1093	0.7%
155	1085	0.6%
163	1081	0.6%
154	1079	0.6%
164	1070	0.6%
182	1060	0.6%
156	1054	0.6%
165	1053	0.6%
167	1053	0.6%
Other values (1088)	156878	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	200	0.1%
2	2	< 0.1%
4	7	< 0.1%
5	9	< 0.1%
6	11	< 0.1%

Value	Count	Frequency (%)
108703	1	< 0.1%
89284	2	< 0.1%
80363	2	< 0.1%
73674	2	< 0.1%
56131	2	< 0.1%

number_of_participants
Real number (ℝ_≥0)

ZEROS

Distinct	219
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.202372004
Minimum	0
Maximum	452
Zeros	28050
Zeros (%)	16.7%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	11
Maximum	452
Range	452
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	9.716306017
Coefficient of variation (CV)	3.034096603
Kurtosis	279.1106459
Mean	3.202372004
Median Absolute Deviation (MAD)	1
Skewness	13.31443745
Sum	536788
Variance	94.40660261
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	80760	48.2%
0	28050	16.7%
2	21524	12.8%
3	8188	4.9%
4	4999	3.0%
5	3789	2.3%
6	2881	1.7%
7	2415	1.4%
8	2049	1.2%
9	1830	1.1%
Other values (209)	11137	6.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	28050	16.7%
1	80760	48.2%
2	21524	12.8%
3	8188	4.9%
4	4999	3.0%

Value	Count	Frequency (%)
452	1	< 0.1%
383	1	< 0.1%
345	1	< 0.1%
330	1	< 0.1%
317	1	< 0.1%

average wind load (1 to -1)
Categorical

HIGH CARDINALITY

Distinct	182
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	38896
-0,01	22063
0,01	21543
0,02	10445
-0,02	10401
Other values (177)	64274

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	38896	23.2%
-0,01	22063	13.2%
0,01	21543	12.9%
0,02	10445	6.2%
-0,02	10401	6.2%
0,03	5863	3.5%
-0,03	5746	3.4%
0,04	3887	2.3%
-0,04	3670	2.2%
0,05	2848	1.7%
Other values (172)	42260	25.2%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	4
Mean length	3.661935784
Min length	1

cumulative hr intensity score
Real number (ℝ)

SKEWED

Distinct	85430
Distinct (%)	51.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-126620.3839
Minimum	-3.214664261e+10
Maximum	211992640
Zeros	199
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-3.214664261e+10
5-th percentile	6904
Q1	25885.25
median	44718.5
Q3	72208
95-th percentile	158584.45
Maximum	211992640
Range	3.235863525e+10
Interquartile range (IQR)	46322.75

Descriptive statistics

Standard deviation	78521415.88
Coefficient of variation (CV)	-620.1325054
Kurtosis	167595.5574
Mean	-126620.3839
Median Absolute Deviation (MAD)	21830.5
Skewness	-409.3680887
Sum	-2.122436198e+10
Variance	6.165612751e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	199	0.1%
56586	15	< 0.1%
83477	14	< 0.1%
13421	14	< 0.1%
36406	13	< 0.1%
25895	13	< 0.1%
30784	12	< 0.1%
35780	12	< 0.1%
28526	12	< 0.1%
3573	12	< 0.1%
Other values (85420)	167306	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.214664261e+10	1	< 0.1%
-67782472	2	< 0.1%
-1048388	1	< 0.1%
0	199	0.1%
103	2	< 0.1%

Value	Count	Frequency (%)
211992640	1	< 0.1%
81628634	2	< 0.1%
46155797	3	< 0.1%
36128217	1	< 0.1%
33313290	1	< 0.1%

avg_heart_rate_cat_org
Categorical

HIGH CARDINALITY

Distinct	803
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

9	4019
1	3168
2	601
3,96	468
4,22	446
Other values (798)	158920

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
9	4019	2.4%
1	3168	1.9%
2	601	0.4%
3,96	468	0.3%
4,22	446	0.3%
4,08	444	0.3%
4,1	442	0.3%
3,9	436	0.3%
4,12	436	0.3%
3,79	435	0.3%
Other values (793)	156727	93.5%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	4
Mean length	3.745665843
Min length	1

avg_heart_rate_cat_adj
Categorical

HIGH CARDINALITY

Distinct	703
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

2	5191
9	4022
2,01	598
2,02	533
3,19	507
Other values (698)	156771

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2	5191	3.1%
9	4022	2.4%
2,01	598	0.4%
2,02	533	0.3%
3,19	507	0.3%
2,99	506	0.3%
2,97	500	0.3%
3,05	500	0.3%
3,21	499	0.3%
2,04	496	0.3%
Other values (693)	154270	92.0%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	4
Mean length	3.721396953
Min length	1

avg slope length (m)
Real number (ℝ_≥0)

ZEROS

Distinct	5146
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2297.915214
Minimum	0
Maximum	180700
Zeros	73348
Zeros (%)	43.8%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1200
Q3	2950
95-th percentile	8550
Maximum	180700
Range	180700
Interquartile range (IQR)	2950

Descriptive statistics

Standard deviation	4375.183206
Coefficient of variation (CV)	1.903979389
Kurtosis	149.8999663
Mean	2297.915214
Median Absolute Deviation (MAD)	1200
Skewness	8.113448453
Sum	385181144
Variance	19142228.09
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	73348	43.8%
1100	2052	1.2%
1200	1835	1.1%
1300	1626	1.0%
1000	1517	0.9%
1400	1432	0.9%
1600	1264	0.8%
1500	1239	0.7%
1800	1136	0.7%
1700	1076	0.6%
Other values (5136)	81097	48.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	73348	43.8%
100	126	0.1%
130	1	< 0.1%
133	2	< 0.1%
147	1	< 0.1%

Value	Count	Frequency (%)
180700	1	< 0.1%
180400	1	< 0.1%
158900	1	< 0.1%
157700	1	< 0.1%
137300	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	df_index	user-id	m/v	weight	age	length	total distance (km)	average speed (km/h)	uphill/downhill hys=8 (m)	uphill8end	uphill/downhill hys=0 (m)	uphill0end	average temperature	max/min gpx height	maxgpsheight	total real energy (kJ)	total estimated energy (kJ)	average power (W)	average estimated power (W)	normalized real power (W)	normalized estimated power (W)	number_of_participants	average wind load (1 to -1)	cumulative hr intensity score	avg_heart_rate_cat_org	avg_heart_rate_cat_adj	avg slope length (m)
0	92645	1748	M	79	46.0	179	87,6	26,47	258	269	503	506	24,7	97,6	-69,4	0	1205	0	101376	0	132	2	0,01	40951	3,32	3,13	13800
1	84976	1748	M	79	46.0	179	75,6	25,76	178	191	393	411	9,6	100,2	-3,6	0	1083	0	103139	0	127	2	0,01	25771	2,24	2,34	1300
2	92619	1748	M	79	46.0	179	75,6	25,76	178	191	393	411	9,6	100,2	-3,6	0	1083	0	103139	0	127	2	0,01	25771	2,24	2,34	1300
3	85041	1748	M	79	46.0	179	80,7	21,75	718	701	911	893	25	553,2	-2	1187	998	89445	75194	118	179	2	0,01	53457	3,06	2,96	7900
4	92684	1748	M	79	46.0	179	80,7	21,75	718	701	911	893	25	553,2	-2	1187	998	89445	75194	118	179	2	0,01	53457	3,06	2,96	7900
5	85058	1748	M	79	46.0	179	87,5	25,22	276	260	523	509	21,4	126,6	12,4	1698	1217	136233	97634	152	171	2	0,01	76020	4,45	4,26	2400
6	92701	1748	M	79	46.0	179	87,5	25,22	276	260	523	509	21,4	126,6	12,4	1698	1217	136233	97634	152	171	2	0,01	76020	4,45	4,26	2400
7	84979	1748	M	79	46.0	179	74,4	25,6	166	176	391	404	2,9	103	5,3	0	1045	0	99881	0	134	1	0,02	28473	3,2	2,95	1400
8	92622	1748	M	79	46.0	179	74,4	25,6	166	176	391	404	2,9	103	5,3	0	1045	0	99881	0	134	1	0,02	28473	3,2	2,95	1400
9	85009	1748	M	79	46.0	179	72	23,58	144	154	338	338	25,7	100,9	3,4	0	844	0	76791	0	95	1	0,02	23620	2,69	2,54	1300

Last rows

	df_index	user-id	m/v	weight	age	length	total distance (km)	average speed (km/h)	uphill/downhill hys=8 (m)	uphill8end	uphill/downhill hys=0 (m)	uphill0end	average temperature	max/min gpx height	maxgpsheight	total real energy (kJ)	total estimated energy (kJ)	average power (W)	average estimated power (W)	normalized real power (W)	normalized estimated power (W)	number_of_participants	average wind load (1 to -1)	cumulative hr intensity score	avg_heart_rate_cat_org	avg_heart_rate_cat_adj	avg slope length (m)
167612	75239	1812	M	78	54.0	178	88	30,76	90	99	305	317	25,2	57,6	1,2	2294	1697	224242	165921	218	215	11	-0,03	55078	3,63	3,6	1500
167613	74745	1812	M	78	54.0	178	64,5	31,21	126	91	362	331	29,2	68,3	-1,2	1588	1203	214088	162243	230	201	9	-0,06	53781	4,63	4,21	1500
167614	74225	1812	M	78	54.0	178	88,8	36,33	217	226	501	510	19,2	60,6	5,2	2154	1989	244865	226041	261	287	9	-0,17	55621	6,2	5,82	1100
167615	74265	1812	M	78	54.0	178	115,5	36,95	450	219	706	467	20,4	307,1	49,2	2730	2595	242596	230628	266	280	19	-0,51	69254	6	5,62	14000
167616	75174	1812	M	78	54.0	178	88,1	29,59	249	252	572	580	14,2	78,3	2,3	0	1492	0	139298	0	185	1	0	34191	3,63	3,21	1600
167617	75221	1812	M	78	54.0	178	84,6	28,53	76	64	329	319	17,1	48	-8,6	0	1328	0	124410	0	153	1	0	48124	4,83	4,3	1000
167618	75170	1812	M	78	54.0	178	160,9	26,85	992	985	1524	1525	17,2	748,7	-37,2	0	2604	0	121007	0	203	1	0	83028	3,91	3,53	21600
167619	75181	1812	M	78	54.0	178	78,8	30,43	162	159	531	530	17,4	60,2	3	0	1400	0	150396	0	184	1	0	28577	3,57	3,18	1100
167620	74919	1812	M	78	54.0	178	70	30,37	100	95	286	286	17,9	51,2	10,4	0	1171	0	141171	0	164	1	0	22958	3,4	3,02	1200
167621	74991	1812	M	78	54.0	178	72,4	26,74	397	406	651	667	18,2	327	-18,5	0	1098	0	112608	0	185	1	0	23768	3,04	2,82	7300

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows